package com.dhsc.local.dao.impl.ywjk.qywjh.jhlxwh;

import java.util.List;

import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.dhsc.domain.jkzx.ywjk.qywjh.JsptSystemCzmxVo;
import com.dhsc.domain.jkzx.ywjk.qywjh.JsptSystemJyrVo;
import com.dhsc.domain.jkzx.ywjk.qywjh.jhlxwh.TjkYclxRyglVo;
import com.dhsc.domain.jkzx.ywjk.qywjh.jhlxwh.TjkYclxSqlVo;
import com.dhsc.domain.jkzx.ywjk.qywjh.jhmxxx.TjkYclxVo;
import com.dhsc.local.dao.ywjk.qywjh.jhlxwh.IJhlxcsDao;

@Repository("jhlxcsdao")
public class JhlxcsDaoImpl implements IJhlxcsDao {


    @Autowired
    private SqlSessionTemplate localSqlSessionTemplate;

    @Override
    public List<TjkYclxVo> queryJhlxcs(TjkYclxVo tjkYclxVo) {
        return localSqlSessionTemplate.selectList("JhlxcsMapper.queryJhlxcs",tjkYclxVo);
    }

    @Override
    public TjkYclxVo queryYclxBycid(int cid) {
        return localSqlSessionTemplate.selectOne("JhlxcsMapper.queryYclxBycid",cid);
    }

    @Override
    public int insertJsptSystemCzmx(JsptSystemCzmxVo jsptSystemCzmxVo) {
        return localSqlSessionTemplate.insert("JhlxcsMapper.insertJsptSystemCzmx",jsptSystemCzmxVo);
    }

    @Override
    public int queryYclxByYcmcAndYclx(TjkYclxVo tjkYclxVo) {
        return localSqlSessionTemplate.selectOne("JhlxcsMapper.queryYclxByYcmcAndYclx",tjkYclxVo);
    }

    @Override
    public int updateYclx(TjkYclxVo tjkYclxVo) {
        return localSqlSessionTemplate.update("JhlxcsMapper.updateYclx",tjkYclxVo);
    }

    @Override
    public int saveYclx(TjkYclxVo tjkYclxVo) {
        return localSqlSessionTemplate.insert("JhlxcsMapper.saveYclx",tjkYclxVo);
    }

    @Override
    public List<TjkYclxRyglVo> queryRyxxByWbbh(Integer wbbh) {
        return localSqlSessionTemplate.selectList("JhlxcsMapper.queryRyxxByWbbh",wbbh);
    }

    @Override
    public List<TjkYclxRyglVo> queryRyxzInfo() {
        return localSqlSessionTemplate.selectList("JhlxcsMapper.queryRyxzInfo");
    }

    @Override
    public int insertRyxx(List<TjkYclxRyglVo> list) {
        return localSqlSessionTemplate.insert("JhlxcsMapper.insertRyxx",list);
    }

    @Override
    public int queryRyxxByBadgeAndRylx(TjkYclxRyglVo tjkYclxRyglVo) {
        return localSqlSessionTemplate.selectOne("JhlxcsMapper.queryRyxxByBadgeAndRylx",tjkYclxRyglVo);
    }

    @Override
    public int updateRyxx(TjkYclxRyglVo tjkYclxRyglVo) {
        return localSqlSessionTemplate.update("JhlxcsMapper.updateRyxx",tjkYclxRyglVo);
    }

    @Override
    public int delRyxx(TjkYclxRyglVo tjkYclxRyglVo) {
        return localSqlSessionTemplate.delete("JhlxcsMapper.delRyxx",tjkYclxRyglVo);
    }

    @Override
    public List<TjkYclxSqlVo> querySqlxxByWbbh(Integer wbbh) {
        return localSqlSessionTemplate.selectList("JhlxcsMapper.querySqlxxByWbbh",wbbh);
    }

    @Override
    public int querySqlxxExistByXhAndWbbh(TjkYclxSqlVo tjkYclxSqlVo) {
        return localSqlSessionTemplate.selectOne("JhlxcsMapper.querySqlxxExistByXhAndWbbh",tjkYclxSqlVo);
    }

    @Override
    public int addSqlxx(TjkYclxSqlVo tjkYclxSqlVo) {
        return localSqlSessionTemplate.insert("JhlxcsMapper.addSqlxx",tjkYclxSqlVo);
    }

    @Override
    public int updateSqlxx(TjkYclxSqlVo tjkYclxSqlVo) {
        return localSqlSessionTemplate.update("JhlxcsMapper.updateSqlxx",tjkYclxSqlVo);
    }

    @Override
    public int delSqlxx(Integer bh) {
        return localSqlSessionTemplate.delete("JhlxcsMapper.delSqlxx",bh);
    }

    @Override
    public List<JsptSystemJyrVo> queryJyrBeforeRq(String rq) {
        return localSqlSessionTemplate.selectList("JhlxcsMapper.queryJyrBeforeRq",rq);
    }
}
